RootZanli & NinjaCr3

: / home / o5t6x7pgljbm / public_html / admin / sqls /

Filename : v4_4_student_segmentation.sql

back

CREATE TABLE student_segments (
    id INT AUTO_INCREMENT PRIMARY KEY,
    school_id INT NOT NULL,
    name VARCHAR(255) NOT NULL,
    description TEXT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    deleted_at TIMESTAMP NULL
);

CREATE TABLE student_segment_user (
    id INT AUTO_INCREMENT PRIMARY KEY,
    student_segment_id INT NOT NULL,
    user_id INT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    deleted_at TIMESTAMP NULL
);

ALTER TABLE student_segment_user ADD COLUMN `import_queue_item_id` int DEFAULT NULL AFTER user_id;